package wyh.pojo;

/**
 * -- 创建 appointment 预约表
 * CREATE TABLE appointment
 * (
 *     appointmentId INT PRIMARY KEY AUTO_INCREMENT, -- 预约唯一标识
 *     patientId     INT,                            -- 关联患者
 *     escortId      INT,                            -- 关联陪诊员
 *     date          DATETIME,                       -- 预约日期
 *     FOREIGN KEY (patientId) REFERENCES patientinfo (patientId),
 *     FOREIGN KEY (escortId) REFERENCES escortinfo (escortId)
 * );
 */

//c．	预约（Appointment）
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

@Data
public class Appointment implements Serializable {
    private static final long serialVersionUID = 1L;
    private Integer appointmentId; // 预约唯一标识
    private Integer patientId; // 关联患者id
    private Integer escortId; // 关联陪诊员id
    private Date date; // 预约日期
}